package com.zhiyun.mapper;

import com.zhiyun.domain.Signup;
import com.zhiyun.vo.Result;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

public interface SignupMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Signup record);

    Signup selectByPrimaryKey(Integer id);

    int updateByPrimaryKey(Signup record);

    List<Signup> selectByCourseAndStudentID(@Param("courseId") int courseId,@Param("studentId") int studentId);

    List<Signup> selectByCourseId(Integer courseId);

    List<Signup> selectByDateAndCourseId(@Param("date") Date date,@Param("courseId") int courseid);

    Signup selectByCourseAndStudentIDAndDate(@Param("courseId") int courseid,@Param("studentId") int studentid,@Param("date") Date date);
}